Absolute motions of globular clusters. II. HST astrometry and VLT radial velocities in NGC 6397