Just over half of UK households (51%) will need to use property wealth in retirement to maintain a comfortable standard of living, according to a new report.