A huge regeneration has breathed new life into this once industrial strip of the city, says Alice Porter, creating a hub of street art, indie hangouts and trendy restaurants that’s well worth a visit