A family has paid tribute to a man with a "heart of gold" who was found dead in a river in Manchester.