From skateparks to artificial surfing waves, the rise of fun facilities across Scotland speaks of a desire to create pockets of utopia, writes Roger Cox