Fort Worth's Water Gardens is pretty cool. They dug out a large area and then run water through them, plus you can go down in there.
It's way more impressive than it looks in the picture.