For going out in Dublin you'll probably find yourself somewhere between the areas Temple Bar and Stephen’s Green which is the popular part of the city for pubs and restaurants. That is something to consider when finding a place to stay. You will find a great listing of music, theatre and more at: www.entertainment.ie
There are plenty of great places to say right beside the venue (Ballsbridge area) OR in the nightlife centre mentioned above. A walk from the RDS to Stephens Green would take 40 minutes, so you might need a taxi.