I am Afghan passport holder and want to visit Macau do I need for visa or not

You need one, but you can apply one upon arriving there. If you want to work locally, you may need to find a work in advance and then go to apply certain work permit. After getting that permit, you can easily work there.

If you just apply one upon arriving, you cannot use it to work, because it is illegal to do so.