A Met Office yellow warning for heavy rain has been issued as Storm Bert is set to cause travel disruption and some flooding this weekend.