What kind of Water Sport/Travel or Luxury can we have at Cayman Islands? I am going with my family?

Google.com will give you links to resorts and travel agents who can tell you everything. Images.google.com will show you pictures. And that is all any of us could do for you.