A rare, red warning has been issued by Ireland's weather service ahead of the arrival of Storm Eowyn, warning of "severe, damaging and destructive gusts".