There are many occasions which can be enhanced by a piper. Some are traditional and some are not. Probably the most traditional are the Burns Night and St.Andrews celebrations.  These can range from a relatively informal Haggis Supper and Ceilidh to a full scale formal Burns Dinner in evening dress with toasts, speeches, songs and recitations of Burns poetry.  My experience of  the planning and organisation of many such events can be placed at your service.
Other non traditional events at which a piper may be appropriate are Remembrance Services and parades, civic banquets and corporate functions.