Spells of heavy rain may lead to some local flooding during Sunday and Monday, according to the Met Office