Flooding downpours to unfold in Northeast as Hurricane Erin spins offshore