Nonlocal diffusion models with consistent local and fractional limits