We had a lot of fun at Morritt's Tortuga Club in Grand Cayman. Lots of activities onsite. Several different dining options onsite. Lots of things to do around the island. The water does have some sea grass and rocky bits, so that might not appeal, but we all loved it.
The White Sand slip-n-slide snorkel tour was a hit with our kids, and it leaves just a short walk away from Morritt's:
https://www.whitesandwatersports.com/tours/double-water-slide-pontoon-boat
We also had a great time (from teens to 74 year old grandfather) with the Jet Ski tour through Fat Fish. They will provide transportation, if need be:
https://fatfishadventures.com/jet-ski-safari/
But this would not be good for little kids... so you might have to pick a more traditional tour if everyone wants to go to sting ray city.