A freshwater conservation project that has delivered both habitat and heritage benefits has been recognised with a national Green Apple Award.