Following weeks of delays, Caerphilly County Borough Council has announced an opening date for its first night shelter, aimed at helping rough-sleepers.