Advanced ab-initio methods to study  innovative materials for water photolysis, investigating the fundamental properties of metal oxynitrides and filling the gap between material science advancement and engineering applications