Sounds like Fun was had! I’m guessing you were going for a proper waterfall? In the future you could try a Dwarven Mist Generator. I like to put them above high traffic areas so everyone has to pass through it constantly.

https://dwarffortresswiki.org/index.php/DF2014:Mist#Ring_gen...