The adventure pack “includes five new dungeons, including the classic module White Plume Mountain, plus four additional all-new tales of mad Wizards and their works. The five quests are not part of a narrative arc, but instead tie thematically around Wizards run amok.”
The patch includes the new Falconry universal enhancement tree and preps for an updated Treasure of Crystal Cove event. There are also many class changes (when are there not?), so make sure to read the full patch notes so as not to be surprised.
Source: Patch notes. Thanks DDO Central!