Dramatic video footage has captured the moment that a man was dragged away by floodwaters as he tried to rescue a woman stranded in her car.