Those water motion ones are really good. To get the motion of the water, you need a long exposure, but this will flood the sensor with light, so you need a Neutral Density Filter to reduce the amount of light coming into the camera.
I'd like to get a couple, but they aren't cheap.