A yellow Met Office severe weather warning will come into force here later on Sunday and last into Monday, it has emerged.