As with all Spell Tomes, Berne's Aura spawns randomly depending on multiple factors such as the Hero's level and spell level. However, for the best odds of finding a Spell Tome, search boss-level chests in Necromancer and Conjurer lairs.