A rare red warning for strong winds has been issued for part of Fife as Storm Eowyn is set to sweep across the country.