Lakeside hotel in Killaloe seem to have one. Also, I know it's not a hotel but Trabolgan holiday village have a water slide and a huge pool with a wave machine. I went there when I was about 14 and absolutely loved it! Also a separate kiddies pool if I remember correctly.