Just as the title says. I play a Bard, College of Lore. At 6th character level I will be able to pick up two spells, of up to 3rd spell level, from any class. I know we will be on the long-term adventure with no easy way to get food and drinks. Goodberries could make it much easier for us, but I do not want to "waste" a 3rd level spell known for a 1st level spell if there is something of more power available to me.
Preference is for material from Player's Handbook and Xanathar's Guide To Everything as it is automatically allowed. If there are multiple spells that meet the requirement, the one with the widest utility wins. If there are none, the highest level and biggest utility are the factor.
Best Answer
The cleric and paladin spell Create Food and Water
Unless your party has more than 15 humanoid equivalents, or more than 5 steed equivalents
That spell should cover your needs, and is the maximum level that you can gain for your bard's level.