Welcome to the center of the universe!
Range-wise, alot of guys use Range 37 in Lillington (~40min drive from main post). There is a POW range on post at McKellar's Lodge, however you must comply with FB PMO policy and register your POWs to bring them on post so that kills it for alot of us. The one "long range" facility in the area is Recondo Operations Group (search for them on facespace), which is about an hour from post and has steel out to 1K on certain days (usually Saturdays).
For sporting clays, Deep River has already been mentioned and also Kidd's Place (near Fuquay-Varina) both have decent sporting clays courses. Ft. Bragg clay target facility did not offer sporting clays last time I checked, however they have a nice skeet/trap facility and you are NOT required to register your POW (shotguns only) to use them there.