Depends on your setup, sit down and lay everything out so you can *see* what is going to happen...i.e. the sump is connected to your pump to you your tank return..etc.
Then think about what gpm you are returning to the tank from your sump, my guess is you'll probably have a 1/2" return line and 3/4" drain or smaller.
Most bulkhead fittings are 1-3/4" outside diameter with a variable inside diameter, to fit whatever siphon diameter you need 1/2, 3/4, 1, etc. Usually your LFS will have bulkheads in supply, if not try a specialty plumbing store, I haven't had much luck with your average Home Depot carrying them.
Most of all take the time to *see* what you are doing before you start drilling. I made the mistake of drilling a 2" hole and I had to specialty order a 2" O.D. bulkhead with a 1" I.D. fitting, which wasted time and money. But you need to understand how the bends are going to effect the head loss on the pump and how that corresponds to your total system circulation.