A crumbling hydro-electric plant in the Yorkshire Dales is to spark back into life to supply power to the national grid.