Coral beaches

Hi everyone

Hope everyone is doing great. I am posting here first time.

I am looking for family friendly recommendations for beaches with the coral reef in reach (snrokling may or may not be an option). I would prefer destinations within North America, Caribbean or Europe. The timing is summers preferably early August.

As fuel is becoming more and more expensive, I would also be looking for recommendation to economical flight deals.

Thanks