From sci-fi libraries to steampunk tearooms, his dazzling creations made Glasgow a design paradise – and even crop up in Blade Runner, Doctor Who and Madonna videos. We join in the 150th anniversary celebrations