Emergency tax is one of advisers' "biggest frustrations" and will become an increasingly thorny problem, Abrdn's head of industry change has warned.