I both Liked and Shared this photograher's image on Face Book. If you are coming from some other link, you can go to the link above to see it. I don't want to post it here because someone might think I took the picture. I did not. I don't even know this photographer. But he does have some nice images. This feathery flowing water effect is often seen to enhance waterfalls and whitewater streams. It is something that you can dovery easily.
You should use a tripod, but any way you can brace your camera to avoid motion blur from the camera movement. You want to use a low ISO setting as well as a high f/stop if shooting this during full daylight. If you don't have the adjustability to allow a time exposure with your camera you can possibly do it on automatic. It won't hurt to try.
But the whole effect relies on a second or more time exposure to allow the steadied camera to blur the moving water as it flows. The longer you can leave the shutter open, the more fluffy it will appear. However, you will be limited in how long of a time exposure you can use by the brightness of the scene. It does not take long for the water to blur sufficiently for a nice look.
This used to be a lttle dicey when using film. The best method then was to bracket your exposure times and take lots of them. With digital cameras, you can merely look at each frame until you get what you want. Still, I do recommend taking several variant exposures as it will provide more digital data to manipulate within the camera after-exposures controls or within PhotoShop, if you so decide.
This is all there is to it. There are a limited number of ways in which I suggest using controlled motion blur toenhance your cameras, but this is on eof the. If you have no stream readily available to practice on, you can use anything from the bathroom tub water tap to a hose outside. While you are at it, maybe I'll write another post within the next day or so about some other kitchen intrigue to photograph.