There's lots of great heatsinks out there that are very good at handling loads of overclocking. Water cooling is only for crazy overclocking experts that overclock by around 1 Ghz or more!

Yes water cooling poses a risk at shorting your electricals if things go wrong.