There has been major flooding across North Yorkshire over night after heavy rain due to a Met Office Yellow weather warning.