Celtic and Rangers have been handed a boost after securing a "multi-million pound" sponsorship deal with Tennent's Lager.