Met Éireann has placed the majority of the country under a yellow alert ahead of the deluge on Sunday