The return to use of Scotland’s oldest market halls is set to unlock the country’s most underused riverfront.