A yellow cold health alert has been issued for the North East as temperatures set to plummet.