The Met Office issued a yellow weather warning for Sunday, September 22 with heavy rain predicted