For this location is very important as you say, firstly conducting some market research and trying to find out where people want a bar is a good idea. Obviously there’s factors such as budget, what options are available and what area you are in etc so there’s only so much i can help. But somewhere with a lot of footfall, in commuting distance of the main run of houses and generally within the heart of the city would attract a lot of people, but if your target audience is different then you might want it in a quieter location where people would go for a quiet drink with a friend. This completely depends on what type of bar it is as well as your local area, the demographic there.

Hope this helped a bit, feel free to message me to discuss this further.