A new section of a cycle route will be opening, as a new bridge is lifted over a "busy" road.