This was a good exercise but not a macro
S mode on my camera, 1/250, F5,6, iso 200 and used my in camera flash.
All the other photo's I took where dull but when I used the flash the water started to sparkle
Tips to get a better shot are welcome
Oooh I hope you didn't get your camera wet! Flash is good for getting droplets to shine. Natural light is great from the side or behind, of course, but that may not be possible in a shower if you have no nearby window.
Have you considered black and white and really cropping so the water droplets look like a glasslike curtain....