Singles and doubles cost the same, so take whichever suits your group. The sea-through doubles have a clear hull — you watch the reef and the fish pass underneath you while you paddle.
The reef is the reason to be out here. Take a clear-hull kayak if you would rather watch it pass underneath you, and snorkel gear rental in Grand Cayman for when you stop and get in.