I had a fortress once where I COULD have dammed the river with great ease, had I chosen to do so.
This was, of course, the fortress where a low-grade cluster-tantrum had me fed up enough to simply seal the doors and windows and divert the river into the fortress. I was so irritated with these specific dwarves that I stayed up for two, three hours watching the fort drown, and the brook went dry past the part where I was draining it.
I think the star of that escapade was the farmer who got trapped in his room when the bedroom level flooded. Somehow he got trapped in there with like 5/7 water, and he seriously managed to survive and make it to something like Proficient swimmer before starving to death (or dying of thirst, which would have been amusing considering the circumstances). Made more epic by the fact that by the time he went belly-up the water level in the fort was two or three z-levels above that layer by then.
Bloop bloop.
Seriously, now, you could try an atomsmasher. I have been using a design where a 10x10 drawbridge linked to a lever set to repeat is surrounded utterly by fortifications, and the outcome is to allow me to drain unlimited amounts of water (or to NOT drain the water, if I want!). It may be a bit of an exploit, but a repeating atomsmasher of 10x10 size can destroy a lot of water real quick.