National Grid has promised to restore a city centre street left 'scarred' by tarmac following public backlash