Diageo is to lose one of its financial executives after AG Barr picked him to head up its group finance department.