Police who were searching for a missing man in Rotherham have found a body.