London is among the cities which could face more frequent and long-lasting droughts in future, research has found.