I do most of my boating in the western Long Island Sound. (Norwalk, Stamford, Manhasset Bay, Oyster Bay, Huntington Bay, etc.) I think that your best bet for a longer term stay would be further east. You can 'hit' areas of interest for overnight stays from the city heading east. For instance...