I spent some time over the weekend redoing the plumbing in my soon-to-be retired 105 gallon reef. It has been running almost flawlessly for 9 years, and has several fish that are older than 10 years. It has a single overflow box, and has 2 bulkheads. One bulkhead is for the drain, and the other is for the return. However, I didn't use the return pipe, since I ran multiple tubes up the back from 3 squids.
I don't really know what the terminology is for the type of standpipe I had, but it was just a tall open-channel with a turn-down on top. I was never able to get it to run silently, but got it to a tolerable volume by using an undersized return pump.
Since I'm about to set up a DSA 180 Extreme Bow Front with the sump located in a remote closet, I decided to prototype my new plumbing on my old tank. I'm not all that concerned by the noise at the sump, but I want the aquarium and overflow to be totally silent.
I started by replacing the Mag 7 return pump with a Mag 12, which almost overflowed my tank. Then I replaced the drain plumbing with parts that had a slightly larger internal diameter (3/4"), and built it out as shown in the diagram below.
I am totally blown away by how awesome this works! If I open the valve all the way, the overflow goes totally empty in seconds, and it immediately starts girgling loudly while air bubbles start flowing into the tank. However, once I start to close the valve, the girgling slows, then stops. The water spilling over the top of the box slowly gets quieter as the water level slowly rises inside the overflow box. I can watch the water level rising at the same rate in the exterior tubing. Once the water level reaches the upper T fitting outside the tank, it starts to spill into the open channel. Once this happens, the water level in the overflow stops rising.
If I close the water valve a little more, the amount of water that spills in the open channel increases. However, I have to close the valve quite a bit before the volume of water flowing down the open channel starts making any noise. There is actually quite a wide range of adjustment where the entire system is absolutely silent.
It's also very easy to optimize the water level in the overflow by simply raising or lowering the height of the upper T fitting in the external open channel. Obviously, I will want to have an emergency return as well, but there's no need to prototype that one.
I'll take some pictures and video this evening.