The bridge connecting Govan and Partick, construction of which began in 2022, is finally set to open with government ministers and local children in attendance.