In Chiang Mai you are not far from anything.  Only 15 minutes to the airport and even if you are staying on the outskirts of the city it is only about 15 minutes by taxi.  The ideal location is in the city centre near the Night Bazaar and shops and close to the Mae Ping River.