In each game: where the item shows up once (on the ground, as a gift, as a reward) and where you can always get it (shops, wild Pokémon holding it, prizes).
Legends: Arceus
Once
Pearl Settlement (reward for defeating Irida to complete Request 90: "The Pearl Clan's Treasure")
Scarlet / Violet
Once
Porto Marinada auction (if the player owns a Palkia)