After three months of closure for repairs, Burnley's aqueduct has opened for use by motorists once more.