Northeast fishing question

So a buddy of mine is getting married and we thought about taking him camping or fishing. Does anybody have any experience fishing in the northeast and know of any good spots?

We live in NYC, but would be willing to drive as far as VT probably.

I've been fishing up in canada and we had access to boats and cabins without anybody looking over our shoulders. That'd be ideal.