Here's the wiki page.

It's not terribly exciting in person, actually. That lighthouse is just a little building. But it sits on the Hudson River near a bunch of docks and marinas, so it's one of the better places to kayak around me.