The ROSAT Deep Survey: III. Optical spectral properties of X-ray sources in the Lockman Hole