Cash-strapped Moray Council has revealed its sports and leisure facilities are operating at a loss – despite a membership scheme bringing in almost £850,000 last year.