Transition from Gaussian to non-Gaussian fluctuations for mean-field diffusions in spatial interaction