Heavy overnight rain has left many roads in Fife under water - including part of Kirkcaldy Esplanade.