Multimillion-dollar project transforms once lifeless lake pit into thriving river: 'We will hopefully ... allow access to any fish that are looking for areas to forage'