The durso standpipe that comes with the marineland corner over-flow is pretty quiet. depends how much water volume you'll be turning over via return pump. I find my return pump, ballasts, and skimmer pump are louder than the corner over-flow
EDIT: assuming you're talking about water/gurgling sound