I've used a herbie overflow on my last three tanks, including my current tank. They are quite.
Water falling from the tank water line level to a lower water level in the overflow causes most of the overflow noise. Air mixing with water in the overflow exhaust (drain) line causes a lot of overflow noise too.
Herbie overflows allow you to control the water level in the overflow and prevent air from getting into the overflow.
Use a gate value, not a ball value. Do not glue any of the fittings in the overflow. It isn't necessary.
I've never used the third pipe you see in some designs. In five years of herbie operation I've never had an overflow.
If one of your two drain lines, i.e. the bulkhead holes, has a smaller OD, e.g. an All-Glass overflow, I suggest you use the smaller OD line for the primary flow line. Also use thin wall PVC for both lines to maximize the drain line ID.
The water level in your overflow should be no more than 2" lower then the water level in your display tank. The further the water falls as it enters your overflow the more noise it will make. The emergency overflow intake should be at or a little, 0.5 to 1.0", under the display tank water line.
The primary flow line intake must be at least 5" shorter then the emergency flow line, i.e. about 5" underwater, to prevent a vortex from forming and sucking air in. The max height depends on the water flow rate. Be prepared to adjust this height a bit.
The exhaust end, i.e. sump end, of both lines must be underwater to prevent noise.
Herbie overflows can be finicky. The water level in the overflow must stay within a narrow range. If it goes too high water flowing through the emergency overflow line will make noise. If it goes too low the primary flow line will suck air in and make noise.
IME it works best to clean the overflow weir and return pump intake then adjust the overflow water level so a little water trickles through the emergency overflow line during normal operation.
Also the fewer "T"s for equipment that clogs during normal use, e.g. media reactors, you have on the return line the better. None is best. As they clog they change the water flow which will change the water level in the overflow and may require an overflow water level adjustment.
When you get it all installed and adjusted turn the primary flow line off to make sure your emergency overflow line can handle the flow.
EDIT: It is possible to install a herbie overflow in an overflow with only one drain hole if the overflow is large enough to hold a "T" and a valve. You will have to reach down into the overflow to adjust the water level.