The dusty heart of nearby active galaxies