Caerphilly County Borough Council is seeking public opinion on building affordable homes on a disused site near Risca.