Guidance of the avatar is the best skill-pumping spell in the game, without question: it gives a +20 competence bonus on a skill check. (2nd-level spell)
Divine insight in Spell Compendium gives an insight bonus of up to 15 (at CL 10th), so that’s another +15. (2nd-level spell)
Surge of fortune from Complete Champion grants a +2 luck bonus. It can also be discharged to treat one roll as a natural-20. You can cast two of them on yourself, one to discharge and the other to stick around so you get the +2. (5th-level spell)
- If for some reason you can’t use surge of fortune, insight of good fortune is in Player’s Handbook II, and lets you reroll the check when you make it. Requires a 20-gp golden die. (2nd-level spell)
Ray of hope from Book of Exalted Deeds grants a +2 morale bonus to skill checks. (1st-level spell)
- If you have essentia, valiant spirit from Magic of Incarnum gives a morale bonus of +2 + the essentia you put in it.
Share talents from Player’s Handbook II can grant a +2 untyped bonus as long as either you or an ally has at least one rank in Diplomacy. The other target need not assist in any way during the speech. (2nd-level spell)
If you can cast Evil spells, and have an Evil ally who doesn’t mind a little pain for this, you can cast willing sacrifice over an over until you get the maximum +5 untyped bonus. (3rd-level spell)
Interfaith blessing could give you +1 untyped to skill checks, if you worship Boccob, Corellon Larethian, Vecna, or Wee Jas. A worshiper of Garl Glittergold, Olidammara, or no deity has a 25% chance of getting this bonus as well.
All told, this hits DC 61 before ranks or Charisma are even considered, and without relying on willing sacrifice or interfaith blessing. RAW, that’s sufficient to turn even a Hostile crowd Friendly, and a crowd that is already Friendly or Helpful will become Fanatic. Doing better than that means hitting DC 90; maxed ranks at your level will get you halfway there. Of course, no one should ever play Diplomacy RAW.
There are no spells that directly interact with Diplomacy in a useful way; most give penalties, and others give smaller typed bonuses than the bonuses above.
Intimidate does have divine presence which grants a +5 sacred or profane (depending on your deity) bonus, and that bonus increases to +10 and then +15 for each alignment axis on which the audience opposes yours (e.g. +15 if you were LG and the crowd was CE). But Intimidate is usually not a great choice.
Eagle’s splendor is still your best choice for improving Charisma. Lesser visage of the deity and visage of the deity have the same +4 enhancement bonus, along with other bonuses that aren’t useful to you, but that’s it.