A murder inquiry has been launched after the discovery of the body of a missing man who had last been seen by his family more than two weeks before.