You can control water flow dynamically during the gameplay by opening and closing Flood Gates.
This is one of the few in-game elements you can control personally instead of indirectly through your characters.
Characters can walk on top of a Flood Gate which makes it super easy to integrate with dams.