The body of a man believed to be dead for nearly a decade has been found in a flat where a council tenant continued to live.