for water shots, you can try to extend the shutter speed for a more "smooth" running effect.

just keep in mind that post processing is equally as important as the camera itself. the powershot line from canon is more than capable of taking good shots

play around with the preset modes, but eventually try using av/tv modes and then M once you think you have everything down.