The water dragon unlocks via an automatic conversation with Julie (at the hut by the river) after going to the moon.
There is 1 bloom per dungeon, it spawns (or not) randomly. If you are missing the 2nd to last, it's in the 2nd to last dungeon (there's also 1 on the moon).
The ultimate challenge is a challenge bloom too.