A new bridge linking divided communities in Derry will be a catalyst for change in the city, Martin McGuinness has said.