Met Office warns change on the way as heavy rain to replace