Water cooling means that you can transfer the heat from the CPU / GPU / north bridge /mosfet etc... to a larger, more efficient radiator, where you can use larger, slower & quieter fans.
You can also avoid having air whistling through your case, across all sorts of cables & jagged edges.
Is water cooling quieter that air?