Heavy rain is set to batter the city as the Met Office issues a yellow weather warning.