No, it is not just a photo.
It is a combination of semi-transparent texture layers and a shader. And it was not so easy to 'paint' the underwater (ground) texture, because I had to remove all reflections and the visible surface of the water (waves, bubbles) from the photo.