It's a casual way to compliment someone. The expression is quite literal - if someone is "looking good" they are looking well/presentable/etc.