An outdoor education base in Carmarthenshire is due to close next year and be replaced by affordable housing.