When asked, my response is usually "it would be my honor to play for the funeral" if it's a person or family I know. If it's not someone I know, it's usually a business transaction, as in they want a piper and I hapen to be one. Simple decorum and courtesy, same as if you were the one providing anything else for the funeral.