If you (or someone you know) has the tools and ability to drill glass, then I don't see a problem. You'd want to make sure the glass isn't tempered, as that's apparently much trickier to drill (I have no glass drilling experience myself).

With no drain, you can stick a short piece of pvc tubing down to the bottom layer and poking above the substrate. Then you always have easy access to put a flexible hose down to drain excess water. Put a removable cap on the pvc tube so crickets and other feeders can't go down to drown.