Rural tourist destinations across the north of Scotland will receive share of £2.6mm to improve the visitor experience.