More Tramspotting than Trainspotting: Leith has reinvented itself as a music and countercultural hub by Edinburgh’s port district has shaken off its seedy rep and is having a cultural renaissance, writes Robin McKelvie