Have you tried these guys?
http://www.gateway-marina.com/
This noonsite link may give you a few more possibilities:
http://www.noonsite.com/Countries/USA/NewYork
I recall seeing stories of people living aboard their boats in the great south bay but don't really know anything about Brooklyn.