There are many places to find textures on the Internet, and these two are from skelletalmess at deviant art.
Most are free to download and so fun to collect. Problem is you end up with SO many its hard to pick and choose a texture so its like playing a game of trial and error. Try a texture and a linear burn or multiply, an opacity or soft overlay.
Here is what I did to my photo. Processed the photo into a dreamy appearance then I added on top of it the blue texture and did a linear burn. Then I added the light colored texture and applied a soft overlay. I again added that light colored texture and repeated the soft overlay. It gives you some cool painterly effects and if you do not like the texture and how you applied the opacity or filter then just delete it!