Cold dust emission from X-ray AGN in the SCUBA-2 Cosmology Legacy Survey: dependence on luminosity, obscuration and AGN activity