To get the flowing water effect, you need to set a long shutter speed and possibly a small aperture as well e.g. f/16 and 1/5 second at ISO 100.
The problem you're facing is that, when the shutter is open for such a long time in bright sunlight, you end up with vastly overexposed shots - since there's so much light flooding the sensor.
Your solution is to use a neutral density filter to block out more of the light that would otherwise register on your camera. Think of this kind of filter as sunglasses for your lens. ND filters are graded by stops i.e. one stop, two stops, three stops etc.
For more info, see the Wikipedia article
here