Former Mid Wales workhouse and hospital set to be transformed into near Net Zero social housing development