The Met Office has issued a yellow weather warning for North East England.