Lattice Quantum Villain Hamiltonians: Compact scalars, $U(1)$ gauge theories, fracton models and Quantum Ising model dualities