Drilling a premade tank is risky. It can shatter if not done properly and I THINK you wiould have to empty out the tank and then drill it. You can take it to a local glass shop and have it drilled but i think you would have to take the pane of glass off. Also if you are drilling the bottom you have to make sure it is not temperes glass or you cant drill it.
Basically you need a diamond glass drill bit and some lubricant(antifreeze, etc.) and preferably a drill press. Determine the size of the hole you want and get a bit that would fit. A 1" hole would require a 1 3/4" drill bit to accomodate the bulkhead.
Do a search on "drilling tanks" and you will find a ton of info. HTH