Woodland Scenics makes 2 water products- EZ Water and Realistic water (most people say EZ Water is far from easy though) Resin works too I've heard. My diorama I'm going to make with my kit form the Young Guns GB will have water in it and I'm going to use Realistic Water (15.00! GEES, I just need a little)
Hope I was of some help.