A rare red alert for wind amid Storm Éowyn has taken effect, shutting down many public services across Scotland.