Hunting high and low: disentangling primordial and late-time non-Gaussianity with cosmic densities in spheres