Building Textures from Scanned Art - Tu-torial.com
Using some traditional methods you can create a great texture with simple watercolor wash and scan in to use and manipulate in Photoshop.