From Victorian splendour to faded seaside resort and back again, Exmouth is rewriting its story; Richard Collett checks out this town in the midst of revival