Huge volumes of water are becoming more frequent as climate change affects the weather in Wales, MPs were told