Yellow River Pedestrian Bridge set to open