Cabinet members in Caerphilly have backed a major house-building project that will bring 1,000 new, affordable homes over the next ten years.