Welcome to the forum!
If the outside temperatures go to 30F overnight, you should still be OK. Especially if you keep the inside comfortable, and turn on the water heater. Below that, it could be iffy. If you connect to the city water, disconnect and drain the hose before going to bed. Reconnect in the morning. By the way, the late season campsites have heater tapes on their water taps.
We pushed it last spring and it was down to 10F in the wee hours of March 13 this year in western PA, but only for a few hours. Things were beginning to freeze, but no damage as far as I could tell. I made the mistake of not draining the "magic" shrinking hose, and had to pour warm water on it to thaw it. The next time this happens I plan to drain the hose and squeeze the water out of it. Then it should expand and work in the morning.
We were up early, trying to make Denver from VT in 3 days. We made it.
If the roads get bad, remember that you can stop and take a break. Better safe than sorry. Even a gas station might let you stay to be off the road.