Devon County Council finds only 54% of local young people optimistic about future