Architect says that Sheffield’s Ball Street Bridge might become a lovely park