Spectral representations in non-separable Hilbert spaces and a general characterization of non-regular representations of the Heisenberg group