Yes you can change the look of a drupal site to whatever you like with theming.
Also have a look at Drupal Showcase.