YOU SAID:

but the bucket of water went missing yesterday

INTO JAPANESE

しかし、昨日の水のバケツは行方不明になりました

BACK INTO ENGLISH

But yesterday's bucket of water has gone missing

INTO JAPANESE

でも昨日のバケツがなくなってしまった

BACK INTO ENGLISH

But yesterday's bucket is gone

INTO JAPANESE

しかし、昨日のバケツはなくなっています

BACK INTO ENGLISH

But yesterday's bucket is gone