The City Art Center is definitely worth visiting. If you walk across Prince Street from the exit, it's right in front of you. It has an excellent collection of Scottish art and many other works of art. The admission fee for the permanent exhibition is free and temporary, with a shop and an adjacent cafe.