Hope 'rubbish' Nottingham street could be transformed under