The site of the north-east’s last department store could be turned into housing as part of plans to breathe new life into Aberdeen city centre.