The search for a missing Edinburgh student has ended in tragedy after a body was pulled from water in the city.