Motorists 'on notice' and train services cancelled due to yellow weather warnings