Brian Cox, Martin Compston and Stereophonics rocker Kelly Jones have starred in footage shot in the city.