With a sump, there is potential for even more noise since you're moving more water greater distances with more gear (ie a return pump). HOWEVER, done correctly, you can have a virtually silent tank. Silence is one of my main personal goals.
To have a quiet reef tank, I recommend using a...