One of the many techniques to reproduces water effects in our dioramas, is with the use of plaster. You have no transparency but still can achieve amazing effects, as you see in this video tutorial.
Thanks to AlexModeling channel on YouTube for this great video.
*****************