I've tried, as well as read about, ten different ways of simulating water in model railroad layouts. Here are the advantages and disadvantages of each, in my experience:
Ten Ways To Model Water
modeling water on a model railroad layout
modeling water on a model railroad layout