Aspects of locality in quantum many-body physics