Move username uniqueness validation to user model

Currently we check username uniqueness via path uniqueness within the associated personal namespace model. This MR moves the validation to the user model.

This issue is part of the work from #427730 to decouple user from personal namespaces.