Fraternity?

first off... i know what a fraternity is, im just wondering is there any difference in which one you join? does each one stand for something different - partying, being smart, etc? does it look good to an employer? Any help appreciated.