Hamiltonian systems with orbits covering densely submanifolds of small codimension