A wealth adviser explains how the Tar Heel State taxes Social Security, pensions, and retirement accounts.