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
Lake Valor (reward for defeating Adaman to complete Request 89: "The Diamond Clan's Treasure")
Scarlet / Violet
Once
Porto Marinada auction (if the player owns a Dialga)