This particular one is in Ohio City, a neighborhood in Cleveland. This park and gardens are located within a few blocks of the Westside Market.
I don't know when it closes for the season, but I assume it's labor day--as that is when many other waterparks close. Check with the city to verify though.
For the link to see information on Kentucky Gardens click here
For instructions to the park (that also has a nice ball field, picnic tables, and a big playground) click here.
It is on the corner of Franklin and W. 38th St in Ohio City.