Derelict site in Cashel set to become social housing develop