It is a good idea to visit AUH in June with your family. AUH is in my opinion probably the best place in the Gulf to live. Much nice than Dubai and certainly better than the rest, Doha, Bahrain and Saudi. Also you will realize that in June it is allready quite hot, around 40-50C, so not much to do except the beach or the mall. And it will remain this way until October, after that the weather is great. If your family will like it depends mainly on your company and the accommodation. But before that check on the school situation. I heard there is sometimes a waiting list of 3-5 years in the good expat schools. And in order to get on the waiting list you have to make a downpayment and pay for an assessment for each child. This could cost you Thousands of Dirhams.