The Met Office has issued a yellow weather warning for heavy rain across the region that has already brought flooding and disruption to transport.