No, you do not need to enter Oman to go kayaking in Hatta. A visa is not required for UAE citizens.