This is really easy to make:
This is what you need to connect the pipes, pipes are 3/4 inch diameter. You need 3 stoppers, 2 T-shape, 2 elbows and one hose connection. For the pipes you choose whatever length you need. Most of the water play I have seen are kid-size, but this one is more than 6 feet tall. I have glued most of the pipes together except the 2 connections on the top to be able to store the structure in my basement.
To cut the pipes, you can use any little hand saw you want, it's really easy.