Major incident declared in Fife following overnight thunderstorms