Vallejio Still Water is a dedicated product to reproduce water in dioramas. The guys from Scale War Machine give us a great tutorial about how to use it.
And don't forget that there are alo non dedicated alternatives, as you can see in the video The ultimate comparative test about products for water effects
*************