i came up against this problem when i was setting up my tank. I ended up getting it drilled at a LFS for 30 bucks a hole and ended up having to seal a chip they put in it in the end anyway. DHyslop sent me this very helpful message about doing it yourself, but by that ploint i had already gone and had my tank drilled. maybe it will be of use to you! Dan, i hope you don't mind me reproducing that message here; I will definitely take this consideration when i set up my next tank. I already understand so much more than i did then.
________________________________________________________________
You can ask at a glass shop, but they might not be willing to do it. Likewise if you can find a good LFS--the kind that a lot of reefers might go to--they might do it too, but it's a long shot that you might find a place like that in Worcester.
Doing it yourself is the best way because it costs little and it is not difficult, however you do need a power drill and a diamond hole-saw. The hole-saw you can get on eBay direct from Hong Kong for about $10, and you can get a bottom end drill from Home Depot for $40 or $50.
Drilling a hole in glass is different from drilling a hole in wood or other materials. Instead of cutting away material you're grinding it away. This generates a lot of heat and dust, so the bit has to be kept wet at all times. When you're ready to drill your hole you should use some plumber's putty or Play-Doh to make a round dam around it, a few inches across and keep it full of water while you're making the hole. The trick to drilling is to keep the bit spinning reasonably fast, but to use very little downward pressure: let the weight of the drill work at its own pace. Expect it to take 5-10 minutes.
Starting and stopping the hole both have unique problems. Starting can be difficult because the bit will jump around and scratch up the glass. Some people will start by holding the drill at an angle, so just one edge of it cuts in and makes a short arc in the glass. Then you can move the drill to the vertical position and use that arc as a guide to put the bit in and get the actual circular hole started with the bit jumping around. A lot of people do this, but I don't like to fly by the seat of my pants, so I use one of these: Craftsman portable drill press.
When the bit comes through the back of the glass it tends to create a rough edge--by that I mean it might take some small conchoidal (clam-shell shaped) chips with it out of the glass. Some people just put some duct tape over the inside glass, but it doesn't seem to me that this helps. I've found the best thing to do is use a piece of scrap glass taped or fastened up against the inside surface. The bit will smoothly transition out of the aquarium pane and into the scrap glass without taking any chips with it.
Drilling is more or less the easy part, you just have to keep those things in mind. The hard part will be deciding how you want to set everything up--where you want the hole and what kind of overflow you want to put it and how you will make that. You can go from something very simple--putting a strainer in the hole and using it as the overflow (what you see in most pet shops that have a whole wall full of tanks of fish connected together) to the overly complex overflows like the one I have on my octo tank. See my thread, Tank Renovations, but keep in mind that this is pretty over the top and you don't need to do all that.
The parts you'll need for plumbing center around the bulkhead fitting. This is the piece that actually goes in the hole and lets you connect things to either end. Imagine a giant plastic nut and bolt with a gasket between them. You slide the bolt through the hole in the glass and then thread the nut on the other end to hold it tight: there's a hole through the length of the bolt that you can glue PVC into it. A length of PVC pipe down to the sump will drain water from the top of the tank there. There's a lot of ways to setup the drain inside the tank. The most conventional way for most pre-drilled tanks is an acrylic or plastic overflow piece: this is the black "Megaflow" device that you see in most new tanks at the fish store. These aren't good as-is for octo keepers because they can just climb over. Putting a simple strainer in the bulkhead might be the easiest solution, or you could build a glass box similar to what I did, except on the inside of the tank (mine is on the outside).
________________________________________________________________________