Indeed you can find hundreds of elephant tours in Thailand and in Chiang Mai in particular. The challenge is to find one that does NOT include riding them.
Elephant’s spines are not prepared anatomically to carry people all day and animals in most tours are often subject to a violent process known as Phajaan. This is intended to mentally “break” them and become completely submissive to exhaustive days of work and humans in general.