The character who will change your Pokémon's Tera type can be found in Medali. Specifically, you can find them in the Treasury Eatery. This is the large building next to the Medali East Pokécenter. In order to get access to the Tera type changing character, you'll need to beat Larry, the Normal type Gym leader first.