A drought has been declared in Yorkshire following record-breaking dry weather in the spring and summer, the Environment Agency has said.