Feted by rock stars but only occasionally recognised in his hometown; creative force Billy Childish has reached a level of fame somewhere between complete unknown and international cult hero. Not that he seems to care, writes George Nott