The alert coincides with a spell of wet and increasingly breezy weather forecast to affect much of Ireland