Council pledges support for rough sleepers