Local weak convergence for sparse networks of interacting processes