Residents celebrate end of zero emissions street scheme