The COS-AGN survey: revealing the nature of circumgalactic gas around hosts of active galactic nuclei