Water physics aren't bad in DF, it is really workable already but, I've thought of a way to handle it a bit more realistically, currently depth of water is between 0-7 or at least that is what we see, where there is a direct physical difference in between every level, I will give an alternate system to what is now being done.
First lets say the water depth is internally 0-15, 0 is still 0, 1 might be enough to wet your feet, as in puddles and brooks, the rest of the values will respond to the values 1-7 by dividing and rounding down for the current effects, as in where you need to swim when you start drowning under bridges and so on.
Not only that, but each water piece between 1-15 will have a speed and a direction, this will also give them momentum as we already have mass for the amount of water in a level.
At each movement the water will move as much as its speed allows (and any sources on the original tile fills up the slack a speed given for the source), if two bits of water should end up on the same tile at the same amount, the water level there will rise and their vector will be averaged if possible, otherwise one of the two bits of water will try to continue to move one tile and have its speed adjusted for it, should it not be possible to speed forward, pressure will be created for the tile.
If any tile of water has more than two higher water levels compared to the any of the surrounding tiles after moving all water, the speed and vector will be adjusted with towards that place (or if several towards the average direction of them (which might increase or decrease the speed of the water)).
If the water was indeed standing still, it would move to the empty tile, this will make filling of a water tank directly after a curve in a river somewhat hazardous, not only will you have the speed of the river creating extra pressure within your water tank you'd effectively have a
water hammer coming increasing the pressure of your tank even more if you do not have the opposite wall shaped to absorb the waters momentum to any effect.
These things gives us some trouble with making water tanks and such, and because of that I've thought about what a fortification and a pump would do to ease this situation, because they still would with real physics.
-Fortification will only let through water of 2 and higher in the new system, somewhat blocking brooks (pressure buildup will however increase the depth of the brook and flood it anyway), and it will only contain at most 7 water, this will have the effect of requiring higher speed or pressure of water to get through at the same amount as it ordinarily would, (not unlike the small holes in a dam (this also makes it possible for beavers to build beaver dams maybe making the first non cavernous site for non intelligent non civilized creatures)).
-The pump in the ordinary direction would reduce the pressure to zero (if non powered) from water at the same height as it is, it would also only contain 7 water as the fortification, pressure stemming from up to one z level above it will be totally canceled and the rest of the pressure will be converted to speed (as speed in a closed tank is converted to pressure one might have several in a row to decrease pressure however.
-The pump in the reverse direction can be unlocked for a different usage (as in carrying water the other way than it usually does) it will have almost the same effect as the ordinary direction pump but any pressure will be converted to speed, and with the extra effect of if 7 or more water passes through it it will give the somewhat modest power (in water power terms) of 40, this will work in the same manner as modern water turbines, a well constructed dam might even store energy and let out water above any turbine to make it a viable river power source during the freeze of water.
This might or might not be hard to implement, but it would be awesome, (it would also create what is needed for realistic floodplains and even somewhat realistic waves)
EDIT: I also might note that I tend to over-complicate explanations, so if you understand what I mean, like what I say and see how my explanation could be simplified, please tell me and I will change it, also if you'd want the credit for that change I would be more than willing to give it.
/Zorbeltuss who has many times thought about suggesting this but only recently come up with the way to stop the flooding of every fort in existence