Lattice quantum Villain Hamiltonians: compact scalars, U(1) gauge theories, fracton models and quantum Ising model dualities