After doing some research, I was able to shortlist Pureit Ultima water purifier and mainly because of the brand image behind it as its owned by Hindustan Unilever. Unfortunately, I never realized that this product would also have a some kind of limitation.
Likewise other water purifiers, will not give you water when there is no power. Because, this product is fully electronically controlled even though there is water in the storage, you wont be able to get water. So, you need to always store sufficient water in your kitchen if in case there is no power for few hours. If you have this much of budget, you should go for a better option which would be lesser priced than this and atleast you wont face this type of inconvenience.