A body has been found in the search for a missing Scots pensioner as his family have been notified.