Southampton is expected to be battered by heavy rain on Wednesday, Thursday and Friday this week – as the Met Office issues a yellow warning.