I wish to embark on a megaproject that, for whatever reason, is not listed on the wiki (making me think no one else has thought this up before).
Simply put, I want to channel water in such a way that there's a waterfall in every bedroom, every meeting hall, every corner of the fortress, all of which will generate mist. In theory, the channel lines would have to look intricate and arcane in order to actually reach any conceivable spot in the fort. And to look pretty.
Here is a prototype:
XXXXXXX X = Wall/Stone B = Bed
XBFWFBX F = Fortification W = Waterfall falling down another z level.
XDXXXDX D = Door
Just as mist can travel through fortifications, so can water. Testing has shown that, in order for water to not 'spill' into the bedrooms, the power of the water has to be relatively low (2/7 or so). In theory, having multiple branching tunnels will cause water rushing in to spread out, never reaching more than 3/7... at least, until it reaches a hole to fall through.
Dwarfs cannot pass through the fortification, since they are not submerged in 7/7 water. Creatures that somehow infiltrate my plumbing system won't be able to pass through the fortification since, not only are they not 7/7 submerged, but they're falling down z-levels at a rapid pace until they hit the bottom.
If the entry for the water you use is 7/7, using a 3x1 hole instead of a 1x1 hole will never cause spillage but only if the entry for the river is 1x1.
Will work:
RRRRR R = 7/7 River X = Wall/Stone
XX XX H = Hole, falling down several z-levels
X X
XHHHX
XXXXX
Will NOT work and will flood your fort:
RRRRR
X X
X X
XHHHX
XXXXX
If there's anyone out there that knows a lot more about water mechanics/physics than me, please share your thoughts! I definitely feel like this is feasible but would take a lot of trial-and-error.