Scottish housing sector bodies ‘deflated’ after housing cabinet role downgraded