A growing number of small firms are boosting sales thanks to securing celebrity endorsements, but doing a deal with a famous figure doesn't necessarily guarantee success.