Oh, I think you are talking about Bow Wow Beach in Stow - here is a link:
Bow Wow Beach
and there are several pet friendly hotels close by for those who would like to make an overnight trip out of it.
Pet Friendly Hotels in Stow, OH, US
Or Columbus could work as it is more centrally located in Ohio - I just don't know of anything in/near Columbus.