Just spoken to a few of the Greek guys at work, they recommend the area around Syntagma square, not necessarily the square itself. The main road that runs out of the square is the main street in Athens and is full of bars, restaurants, shops etc. Also the area between Syntagma and the Acropolis is old style Athens with plenty of bars and clubs.