"Look at you!" is usually a way of remarking on some aspect of another person's appearance (or sometimes attitude/behaviour). It can be appreciative (e.g. if someone is nicely dressed) or critical (e.g. someone looks a mess). The tone of voice will help to convey the speaker's intent.