You have not mentioned your price range. There is a tremendous amount of variety in N. Scottsdale. Some of the areas I like include, Grayhawk, D.C. Ranch, Terravita, Bellasera and Desert Mountain (far north).
All are gated, secure, upscale with loads of amenities. All these communities have large "snowbird" populations. There is just so much to choose from today, at great prices, that you need to identify which amenities are most desirable for you and narrow down your search.
Let me know how I can help.