Several of the UK’s northern cities are transforming once neglected passageways into bucolic oases; community spaces filled with urban art, herb gardens — and civic pride