A long-awaited report on Russia's activities in the UK has concluded that the British government "took its eye off the ball" and failed to respond to Moscow's threat.