A sick dog was tied up in a jacket and drowned in a river in England in a "barbaric" killing, the RSPCA has said.