A man who has had sex with so many women during his lifetime and/or has become a very well-reknowned male pornstar, that many people who know him consider a legend.
And yes of course, the term "golden gun" refers to that man's penis.
Ron Jeremy is an excellent example of someone whom you'd like to call "the man with the golden gun."