At least 51 people have died after heavy rain caused flash flooding, with water bursting from the banks of the Guadalupe River in Texas.