The former manager of a Scottish social care charity has been sent to prison after pleading guilty to stealing £40,000 from vulnerable residents