More than £900 million will be committed to major sporting events and grassroots sport across the UK in a “transformational investment” over the coming years, the Government has announced.