Typically, large tanks are produced from tempered glass. Drilling holes in tempered glass is quite different than drilling a hole in plate glass or float glass. Tempered glass has built-in stresses that give it strength. When you drill into it, it changes the stress pattern and the glass can break. If your glass guy has experience in drilling tempered glass, then he might be able to do it successfully, but otherwise, he might destroy your tank.
If you do decide to take the risk, you need to purchase your bulkhead fittings first and then drill the holes based on the diameter of the fittings. The size and number of the bulkhead fittings will depend upon the size of the return pump you plan to use with the sump. For a 200 gallon aquarium, you will need a pump rated at about 1800 gph flow rate such as the Danner Mag Drive Supreme 18.
There are two other options. One is to use an
overflow box. Here is a video that shows how they work. With a 200 gallon tank, you will need two large overflow boxes, one at each end of the tank.
The other option is to use a
canister filter as has already been suggested.
While sumps are highly recommended for saltwater aquariums because the provide space for trickle/shower filters,
protein skimmers, etc. they are not necessary for freshwater aquariums. A combination of
HOB filters and canister filters can get the job done quite nicely. Remember that with sump systems, if they are not designed properly, a
power failure can cause the sump to overflow. Unfortunately, I have had to mop water from the basement floor on a few occasions.