The Raleigh creative has earned a reputation for whimsical, large-scale works — especially inflatables — that bring joy to public spaces