The search for a Fife pensioner who was reported missing has ended in tragedy after a body was found.