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