
The first thing to note is that the lighting is not bad to begin with and you can seen the water in the original. You can't make something from nothing.
Since I didn't need to lighten the photo, the first thing I did was make a duplicate layer and set the copy as "soft light" to bring out the colors. Play with the obacity on the copy layer until you like it.
Then I merged the two layers.
Then go to layer>new adjustment layer> levels (click OK)When the levels box comes up click on the white dropper. Then zoom in on one of the whitest water sprinkles and click. It looks like this.

Not exactly what we are going for, but you can really see the water!
Click "OK" on the levels box and you have a new layer by your picture. Now reduce the opacity on the levels layer to about 10-15%. This allows the water to stay a little brighter, but not so extreme
After that you can touch up with another "soft light" layer, or a sharpen filter. This is the final product:


