Go for cafes in Hudson lane and satyaniketan. There's a wide varietyfor great food, good ambience, drinks and sheesha! I will suggest you to go for 736 AD in Hudson lane and few cafes of Satya which are back benchers, pipeline and off campus.
* Also you can check out My Bar Headquarters which is a go tk cafe at CP *