The apparatus is not connected at the red line in this image. The part to the left (the wheel) is on the ground and farther away, the part to the right (the start of the track) is in the air and closer. They just happen to line up due to forced perspective.
The water just seeps down into a hidden reservoir in the left part, and is pumped up at the appropriate time from another reservoir in the right part.
Edit: see below, it looks like the discontinuity is at a different point.
It looks like, given the reflection from the water, that section of the track can't be more than an inch above the floor. If thats true then wouldn't the break have to be somewhere after that point?
If I'm missing some huge detail can someone explain it to me?
EDIT: I made a diff in GIMP of the shadow. It looks like both the top and bottom left facing ledges are connected. Notice the hard edges between the adjacent pillars.
Next, ignore the beams, and focus only on the water track. Despite looking like it's climbing up, it's actually totally flat (i.e. you could make it from one sheet of wood). But tilted slightly so water flows from the start to the end.
Additionally the entire structure is not actually sitting on the garage floor, but rather is high up in the air, and the camera angle obscures this.
Hidden under the structure is a pump and an outlet at the true start of the track.
He pours water into the catch basin at the end of the track, and that same moment someone else starts the pump. If you watch closely you can see how it looks like the water he pours is being "swallowed", and does not actually flow down the track.
The water from the pump flows down the track, and out the spigot over the wheel and into the bucket.
Next you place beams carefully cut at angles to make them look like they are holding the track - but actually they are open on top.
But this is a pretty amazing piece of work.