Remnants of rain from Storm Agnes trigger yellow weather warning for South Wales