The Met Office's yellow alert also warns of possible road disruptions