A new cafe and canoe and kayak school will be features of the restored length of waterway