Most boat trips take place in the North Sound and include a stop at Stingray City and a snorkeling stop at the Barrier Reef or Coral Gardens. Some trips also include a stop at Starfish Point and Rum Point or Kaibo so be sure to inquire about the trip itinerary first. If you're staying in the Seven Mile Beach area, you'll likely depart from the Cayman Islands Yacht Club, Safehaven Marina or Camana Bay. If you're staying out in East End, you'll depart from Rum Point or Kaibo depending on the operator. Many vendors offer complimentary pick up so transportation shouldn't be a concern.
Red Sail Sports offers catamaran trips with beach pick up at the major hotels along Seven Mile Beach. They also have a concierge desk at these hotels as well so you can inquire further and book on site.
If staying in East End, you'll find unique options from White Sand Water Sports at the Wyndham Reef Resort.