It depends on the restaurant. If you have had to give a CC number, you most definitely will need to cancel, so you won't have your CC charged for being a no show.
However, if that isn't the case, you don't HAVE to cancel, although many others who may want to eat there would appreciate it if you did.