I model my water a little differently than most people. For most of my water scenes I use real water. Personally I can do more with real water, I just love to make waterfalls with real water.
Above was 3 tanks with real water for a sea world attraction, there was a dolphin swimming and jumping through a hoop, another dolphin jumping to get food from a trainers hand and a seal swimming around pushing a ball on it's nose
Above near the top right side is a working dam between the different sections of the waterfalls. The dam has 1 gate in the middle which would open every 1 minute to release water from the back side of the dam. Just before each minute the water would start coming over the top of the dam and then the gate would open.
Near the back of the lake are 2 men, each one balancing on their own log and as the logs roll in the water both men try knocking the other one off of his log.
A bridge opening and closing.
2 separate waterfalls dumping into one lake
Here are 2 fire dept. ladder trucks squirting into the building which is on fire.
Here are a couple of water fountains operating with color lights underneath changing colors.
Above is a operating highway which crosses the lake. On the backside of the highway fog is rising off of the water.
Above is some simulated water which I used since this was a very small & remote area of the display.
Real water used to make the waterwheel turn on the grist mill.
Another simulated water which I used since this was a very smallarea to work with..
I have also had scuba drivers and assorted fish swimming under water. Along with boats moving and many other animations that I have built over the past 45 years.