Weakly stationary stochastic processes valued in a separable Hilbert space: Gramian-Cram\'er representations and applications