Check out my gallery.  My last post was a waterfall image.  I painted the water in in the postwork phase by using Photoshop brushes purchased here in the Renderosity marketplace.  If you have Photoshop then all you have to do is create your image, buy some brushes and the rest is "easy as pie."  If you any questions just IM me.  Good luck.

G&C