I don't know what you would consider the SLC area to be as it covers quite a bit of region, but Pony Express is a newer campground that is off the 215 beltway on the west side of the city. In-city camping is probably going to be a bit noisy anyway. The SLC airport is off to the west but I don't think that would be a problem based on distance and runway approaches. If you're willing to drive about 45 minutes away from SLC then look at Mountain Valley in Heber City, just south of Park City. It is typically a bit cooler in the summer and, if you're not traveling with children, ask for the adult section of the park.