When it comes to macro shots nothing beats a good "freeze shot" of water. It's a good starter shot that you rarely can go wrong with.
Pick your background wisely as it will reflect/shine through the water quite a bit. It is here the real experimentation and potential lies. Good lighting is second. I put two bare strobes left and right, right beside the camera. Put on my 100mm 2.8 macro lens and cranked off a few shots remotely while holding the garden hose close to the flower. Strobes were in fired in manual mode at 1/16 and 1/16 + 2/3. The sun was shining from a cloudless heaven as well.
Adding water to the shot is the easiest part. With a shutter speed of at least 1/200 or above you will freeze the motion quite well. Just take care not to hit your gear :-)
Afterwards the water in the photo was sharpened a bit and the background blurred a little. A slight increase in saturation of the water was also done to make it "pop out" a little.
