Poisson and Gaussian approximation of weighted local empirical processes