This tutorial will show you how to use a variety of Adobe Photoshop tools for process of painting the water in various forms. It will also explain the rules behind all of these, so that you can modify my examples to your needs. The most important lesson from this will be how to use filters to create all the textures you need in a few seconds.
