OK, going to sound in here. A well designed and implemented watercooling system will not leak unless something drastic happens to it (like falling down a flight of stairs). If your system is going to leak at any point in time, it will happen when it is first put together. Sure, you might have a freak accident where a seal breaks on a water block, but this is outside of the norm, and most reputable water block manufacturers will back up their hardware.
As far as maintenance goes, follow sage advice. Preparation in advance will reduce the time and effort you take later in maintaining the system. First, make sure you clean all the pieces before you assemble the system with vinegar and then rinse liberally with distilled water. Soak your water blocks as well. Use ONLY distilled water. Tap water has free ions and will conduct electricity. It also is a breeding ground for algae. The best advice is to use distilled water with an antibiotic agent. You can use expensive products like Fluid XP+ as well, since it has built-in antibiotic properties. You will also want to use an anti-corrosive agent in order to prevent galvanic corrosion, or you can avoid this by limiting your water blocks, radiator and connectors to either aluminum, copper or brass, but do not mix the metals (ie, do not use an aluminum radiator with copper water blocks).
If for some reason your system does develop a leak, if you are using distilled water with anti-corrosive and antibiotic agents, then you have little to worry about, since distilled water is anionic and has great dielectric properties. Shut your computer down, open up the case, clean up the spill with paper towels, fix the leak and put a big fan in front of the open case for a few hours. Your computer should reboot just fine as soon as it has dried out. Fluid XP+ is also anionic and is just as easy to clean up if a leak should occur.
xnamerxx, I'm sorry you had such a bad experience on your first water cooling setup. Yes, maintenance can be a bear, sometimes. But to tell you the truth, since I switched over to Fluid XP+ with my latest build, I'm going on 7 months now without seeing anything in my fluid, where I used to have to change the fluid at least every three months before due to cloudiness from algae. It ain't cheap, but then, neither is my time.