A new fish pass in the north east has led to juvenile fish being spotted upstream for the first time in 300 years.