If you join with Harkon, you become a Vampire Lord and are cured of Lycanthropy.
And from what I understand, if you were a werewolf at the time of becoming a vampire lord, you return to being a werewolf upon curing yourself of being a vampire lord. Could be wrong about that, though, but from my understanding so far, there are no new ways to become a werewolf again in Dawnguard, at least none that have been truly confirmed, that is. Guess we'll know for sure in the next couple of weeks.