A yellow alert for heavy rain has been issued for the county, with potential for gusty winds, travel disruption and flooding.