Hi! No, he shouldn't have any trouble finding it, unless of course if it's somewhere that your hamster can't get to, so I always keep it on the ground floor, just so that it's always in reach.
He should find it. Think of it like this, when you first got him and brought him home he will have found the water source. Just make sure it is still easily accessible where you move it to