Plans that evolved over more than two decades are about to become reality as a 6km cycling, walking and nature corridor opens through Sydney’s inner west