Drone footage shows scale of flooding in Dumfries after river bursts banks