Brumbies' Hooper set to join Waratahs