From lacklustre lodgings and past-it palazzos to dilapidated digs and beaten-down B&Bs, intrepid renovators breathe new life into empty and unloved hotels, guesthouses and mansions