McCartney is set to enjoy watching two of his former clubs go at it in the AFL Grand Final