First, make sure that you're weaning because it's the best decision for you both. You don't have to stop because other people look at you funny. But if you're ready, jump in!
Secondly, I know how very special that nursing time is. It's something that only moms can do - it's the ONE thing that no one else can do for your child! My three weaned at 19, 16 and 14 months
To me, it sounds like you're not firm in this decision yourself. I think the first step is for YOU to really feel firmly that this is IT, the time is here. If you waver in your mind, you're doomed - they're psychic little buggers and will always sense your weakness! :)
Something that will probably help you is to remember - yes, it's a bonding time, but this is supposed to be FOOD. Food = comfort or love is actually not a great message for our kids. Now that this isn't a truly necessary food source for your son, find another way to give him that same love and bonding and comfort. That's really what both of you are looking for at this point anyway, it sounds like.
He's not going to think this is a great idea - that's where you being firmly resolved and very clear in your own mind will be vital. Have lots and lots of fun, new little treats on hand (little plastic animals, new matchbox cars, cool bandaids, stickers... anything he'll find interesting), ready to dazzle him into distraction. First step is to tell him, "all gone!" with a cheerful, matter-of-fact voice. Do not make it sound sad! Just one of those things that happens and no big deal (you can have your emotional moments later, not in front of him). If that doesn't work, sing a favorite song, do a dance... Defcon three erupts, pull one of those bribes, um, treats out!
Keep him distracted and busy; present this as a perfectly normal, not at all sad thing; be kind about it and don't tease him by holding him in the same way/direction/place that you would to nurse (while you're in this transition phase, at least); and STAY FIRM - whatever you do, do NOT give in. That's about the equivalent of taking forty steps backward. I know it's hard (you mentioned giving in to him in your request), but now's as good a time as any for both of you to learn how much easier things can be when Mom means what she says every time!
Good luck - weaning is sad for mom, too, but I know you can do it!