A council housing manager defrauded his employers of £300,000 to help "vulnerable" people because he felt guilty, a court heard.