A Yellow weather warning has been issued in Southampton as the city is expected to be battered by rain through the night.