I'd say Deerfield, MA.

For dirt roads, I'd use as much of the D2R2 routes as possible. I'm sure there is nice road riding on the paved rural roads of that area. For the canoe, I'm sure there's something around that fits the bill, perhaps the Green River or the Connecticut.