A £2 billion funding package has been secured to construct a 196km subsea and underground electricity cable between Scotland and northern England, the UK government has announced.