<p align="justify">Drupal is a free open source content management system which can be used to administer a dynamic websie. Drupal can be used to create a variety of websites which include but not limited to followings</p>
<li>Corporate web site</li>
<li>Personal web site</li>
<li>E-commerce web site</li>
<li>Social Networking site</li>
<p align="justify">Drupal is free and comes with GNU license and supported by a huge community. </p>
<p align="justify">Some of the shortcomings of drupal are</p>
<li>Drupal is not so user friendly when it comes to the admin interface</li>
<li>Drupal theme itnegration is difficult</li>
<li>For any small tweaking you need to know a lot more than php/mySQL</li>
Drupal is undoubtedly the best open source CMS package still functional and thanks to the community support it keeps on growing leaps and bounds. However not all is rosy with Drupal. It is the most difficult to customize and use and certainly it is not for a non technical person. However once it is configured and person using is trained it can become as easy as any other easiest CMS.
Drupal installation is easy as with any other open source CMS which are in php/mySQL however customization, configuration and modules tweaking is for experts only.
The best part of CMS is its SEO module which is the most complex SEO modules I've ever seen in any PHP based script and luckily it works all the time.
Druapl Theme Design
You will certainly need a new drupal theme deisgn which is 2 step process. In first step you have to get the web design done as per your choice and in 2nd step you need a Drupal themer to convert design into Drupal theme.