Just built this fun water station for my nephews using PVC pipes, sprinklers, buckets and clear tubing. Lots of fun and pretty easy set up.
Here's another station I made for my sons school. This one has a cascading design to fit the different heights of his classmates. I also has fun with a dustpan cascading feature.