In some states, attorney-Notaries have the so-called "privilege" of notarizing for clients without their legal fees -- which generally are far greater than what can charged for a notarization -- being regarded as a disqualifying, beneficial interest. But it's probably not the best idea.
The essential role of a Notary is to protect everyone's best interest by serving as an impartial, third party witness. Attorneys are paid to be advocates for their clients, a role that violates notarial impartiality. That's why it is always best and safest for lawyers to have another Notary notarize documents for their clients, regardless of what state law says.