Can a friend or family member acting as executor charge for their work?
No. However, they can take their expenses (for example, for travelling, phone calls, employment of agents to track down missing beneficiaries, or even handing over to professional executors) from the estate, though they would have to keep details.
Executors can benefit under the will, and it is quite common for the principal beneficiaries to take on the job. In fact, appointing your principal beneficiaries as executors means they are already rewarded and they have a vested interest in getting things done fast and well – so they get their full entitlement sooner.