The footbridge connects Station Street to Queen's Road and was previously closed in a controversial three-week trial