Extreme weather is likely to impact New Year's celebrations across the north and north-east.