The old-school New England island has become a favourite retreat for US presidents, playwrights and pop stars, and it isn't hard to see why