Perspectives on local covariance