The Met Office has issued a yellow weather warning for many regions of the country this weekend