Do I need a local UAE sponsor or employer?

No. The Golden Visa is a self-sponsored residency. You have 100% independence to live, work, or start a business anywhere in the UAE without the need for a national sponsor or a specific employer.