When in Chiang Mai, I stick to Hotel Mercure near the provincial bus station. Large rooms, friendly prices, great staff, and within walking distance to the bars and some massage places. Not a lot of tourists, and free shuttle at night to and from Night Market.