A motorist whose car was swept up in floodwaters from heavy rain has been safely rescued from the roof of his car.