It's not overly dangerous to turn a small pool of water into a u-bend, from where you can direct water wherever you need it. I did some experiments with this without any experience with u-bends, and while I did manage to flood a small section of the tunnels used for digging out the system. If I did it again now I could do it without any risk at all.
Basically I have a u-bend connected to a water tank - which is strictly speaking not necessary. It is connected via a floodgate to another water tank. This tank has a floodgate that leads to a vertical shaft going both up and down. Downwards is another floodgate that connects to the underground water reserve of my fortress. This can easily be filled one tank at a time - I can drain the #2 tank, close access to the reserve and refill #2 by opening the floodgate to the u-bend.
Upwards is a windmill operated pump taking the water further to fill my moat. Water generated by u-bend apparently only has enough pressure to rise to the highest point of the u-bend. The floor I have the pump on is perfectly safe even with access open all the way to the u-bend, so when I'm filling the moat I have all floodgates open but the one leading to the water reserve.
I think I'm going to have some fun in the future toying with these... (until, of course, it's fixed, but then I just need a river)