Bahrain is a beautiful country with many nice places to see. Manama is the main city and you will most likely stay there, there are great restaurants and spas and some some nice beaches.
Apart from the city type things you won't see much in the way of tourist attractions in Bahrain. There are a few old forts which are interesting, some museums, and fishing and scuba diving.
Many people who live in the Gulf area go to Bahrain for the weekend (especially from Kuwait and Saudi - because there's no alcohol in Kuwait or Saudi mostly!). Bahrain is the watering hole of the area and has a lot of cool clubs and bars.
Check site below