I meet a lot of riders from the Boroughs that come Noth for the scenic and less hectic roads. The trip up the river North is really nice. There are three destinations you can Google map and stay along the River. Bear Mountain, Perkins Drive, Seven Lakes Drive.
On our side of the River, Cold Spring or Beacon NY. Try to use Rt 9N or 9D for these runs. Guys travel from LI to come up here.