Studying Quantum Gases In A Dynamically Tunable Lattice With Sub-Lattice-Site Resolution