Inverness and the Highlands will see a multi-million-pound boost by becoming the new home of the European Pipe Band Championships for the next three years.