Nature of self-diffusion in two-dimensional fluids