To create realistic running water...

Tutorial Source from: http://www.tutorialized.com/view/tutorial/Realistic-running-water/41424

! Wrap ~useful transformation

1.Create a new layer. Press d to sett default foreground and background color. Go to Filter->Render->Clouds.

2. Go to Filter->Blur->Gaussian blur. Set the radius to 6pixels. Then go to Filter->Blur->Motion blur. Set the angle to 90degree and distance to 80pixels.

3. Go to Filter->Artistic->Plastic wrap and apply following settings: highlight:15, detail:10, smoothness:10.

4. Go to Filter->Sketch->Chrome and apply following settings: Detail: 0, Smoothness: 8.

5. Then go to Edit->Fade chrome and set blending mode to Hard light.

6. Now go to Edit->Transform->Warp. Move the anchors so that it is shaped as running water.

7. Add some background color or gradient(It's better to use blue shade so that the effect looks realistic) and change the running water layer's blending mode to Hard light.