Deadman’s Cay Airport: This is the practical gateway: it is in/next to the Deadman’s Cay settlement rather than a separate city-center airport. There is no useful public-transport transfer. Pre-arrange a rental car for collection at the airport; it is the right move for Long Island, and the accommodation strip around Deadman’s Cay is roughly 5–15 minutes away by road. Taxis exist but are limited, generally must be arranged in advance, and fares are not reliably posted—agree the total fare before getting in.
Stella Maris Airport: Use SML only if its flight schedule or your hotel in the far north makes it materially better. It is about 50 miles/80 km north of Deadman’s Cay—allow roughly 1¼–1½ hours by car on Queen’s Highway. A pre-booked rental is essential; a one-way taxi is a costly, availability-dependent proposition rather than a sensible airport transfer.