We use that style on our ranch for the water troughs for the cattle. We don't use that to keep things quiet, we use it because it is so reliable and sturdy.

Especially when you have livestock that try to drink, bite, kick, and swim next to the overflow!

Of course, we used metal pipe, not plastic!