New restaurant openings and office deals offer hope for Scotland's biggest city