Anywhere between the city centre and Byres Road in West End would be the best bet. Plenty places to visit and things to see including what you are looking for from a short stay. Bonus being all within easy walking distance of good pubs, restaurants and sights.