Statistics of The XXL Survey: XII. Optical spectroscopy of X-ray-selected clusters and the frequency of AGN in superclusters