Water shots can be quite complex and time consuming, specially if you try to simulate it (very undesirable). You might try animating a nurbs surface using deformers with a really nice water shader. Of course there will be some particle work as well for droplets, splashes, and wakes...