Rising floodwaters from the remnants of Hurricane Harvey sent thousands of people scrambling on to rooftops or higher ground in Houston, overwhelming rescuers who fielded countless desperate calls for help.