A ?1 million plan for a museum at Haltwhistle station was drawn up, which was expected to attract more than 10,000 visitors a year.