More than 1,000 households have dropped off the Powys housing register over a three-month period, a report has revealed