The best place to have coffee in Chiang Mai: good taste, good price and beautiful place (not too fancy, just nice). Right at the center of old city, few steps away from Wat Phra Singh.
Chiang Mai night market are usually quite long and super crowded, so it could be quiet tiring. Do visit if you fancy street food or shopping. At the western end is a beautiful golden temple which still open at night.
Clean, quite and comfortable. Comfortable bed and pillow. Free snacks available.
The only complain is the AC blow on your face, so might need to adjust that before sleep.