What I do is construct a tunnel system like so:
# = wall
pP = screw pump
= open space
_ = floor
* = screw pumps arrayed in a column so as to bring water from the bottom to the top of said column
Vertical slice:
# pP #
#*## # # #
#*## # # #
#*## # # #
#*## #_____________ # # ______
#*## ##############__# # ######
#*##____tunnel_right___# ######
#____tunnel_left__________######
The pit to the right of the column without the screw pump (that column is the fountain) catches the water that comes out of the top of the fountain (there's one on the other side too that comes around the fountain and connects but you can't see it in this slide).
To start the fountain, I add water to the pit surrounding the fountain. I probably have some sort of tube going into that pit from elsewhere to add water in case of evaporation. This water flows down into tunnel left and when in sufficient quantity/over sufficient time gets to the tower of *'s, which represent a screw pump device for transporting water to the top since I didn't want to have to draw one out in full. This water is immediately transported to the top of the screw pump tower and falls down into tunnel right. Once enough water gets to the end of tunnel left - thus being pushed into tunnel right - some of it overflows the top of the fountain. This water falls down into tunnel left and is brought up by the screw pump tower to be pressurized into tunnel right, which forces more water to come out of the top of the fountain, which then falls down into tunnel left and is brought up to the top of the screw pump tower pressurizing tunnel right and forcing water out of the fountain which falls down into tunnel left and is taken in by the screw pump tower device to pressurize tunnel right and cause more water to come out of the top of the fountain, which, in its own turn, falls down into tunnel left and is eventually brought to the base of the screw pump device and pulled up to the top of said screw pump device causing tunnel right to become pressurized and shoot more water into the air at the top of the fountain which then falls down into the handy collection pit which routes the water into tunnel left taking it up the screw pump tower and forcing it down into tunnel right, pressurizing tunnel right and getting more water to come out of the top of the fountain, which yet again falls to the bottom of the pit and then flows into tunnel left, flies up the screw pump tower at the speed of dwarven machinery forcing some more water to come out of the top of the fountain which never splashes onto your dwarves, instead, always going into the entrance of tunnel left and onto the base of the screw pump tower causing it to be brought up through the screw pump tower and into tunnel right, displacing more water, which, having to go somewhere, is forced up through the fountain and into the dreaded sunlight which might dry up some of the water as it falls down the slopes of the fountain into the pit and to the base of tunnel left which takes the water and flows it to the base of the screw pump tower by the power of hydrostatic pressure which is useful when the screw pump tower takes the water and puts it at the top of the left tower of water in tunnel right and which causes said water to come out of the top of the fountain into the glaring sunlight which will eventually dry up the water thereby preventing said water from falling out of the top of the fountain and into the pit, which would take it to tunnel left, which could bring it to the screw pump tower, which might take it to pressurize tunnel right which would then expel it out of the top of the fountain but for the fact that no more water exists to be pushed out of the top of the fountain from tunnel right by the screw pump fountain, which, incidentally, got it from tunnel left which took that water from the pit which had water coming into it from the top of the fountain due to sunlight.
I have used neither copy nor paste.