Drainage layer and drill a hole in the bottom (or very low in the back. Just make sure you're not drilling into tempered glass) so the water has somewhere to go if you have an accident or something. Use a bulkhead with a grate/filter and run PVC to a bucket or something to catch it.

Flooded substrate is not fun.