Looking for a location that will allow cruisers to spend the day. Would like place with beach service food/drinks. Kayaking, snorkeling would be awesome.
Not at all helpful Colorado Smushie
Odd, this looks likes a lengthy and comprehensive answer to your exact question.
Searching the main Cayman Port of Call page linked in my first response for the words "beach" and "snorkeling" yields multiple pages of similar discussions. What additional help are you looking for?
I agree with Smushie.....that site is specifically geared towards cruisers looking to enjoy one day on GC.
Top of the list would most likely be Royal Palms. Google it.
You have a few choices. Royal Palms has food and drinks, chairs you can rent and water activities as well. You'll find the same at Public Beach where you can get food and drinks at Calico Jacks. A great snorkeling stop along Seven Mile is Cemetery Beach. You could go there for a snorkel first and then head to one of the beach bars for a snack and drinks.
As recommended above, Royal Palms, Tiki Beach or Public Beach/Calico Jack's are the easiest, but you'll have to walk a bit for any real snorkeling. Another option is an excursion to Rum Point.